COUNTA3D

Counts the number of non-empty cells in a range of cells in the whole workbook.

COUNTA3D is very similar to the COUNTA function of Microsoft Excel. The main difference is that COUNTA3D considers all worksheets, while the original COUNTA function doesn't.

Syntax

COUNTA3D(range_input, include_current)

range_input - is the range from which you want to count the non-empty cells.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Remarks

• In this case, a value is any type of information, including empty text ("") but not including empty cells.
• If you do not need to count logical values, text, or error values, use the COUNT3D function.

[ ©2000-2001, Edwin H. B. Tam, All rights reserved ]